package com.company.project.mapper.ldjsc.sjyt;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.company.project.entity.ldjsc.sjyt.JscSjytGzjyEntity;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 *
 *
 * @author wenbin
 * @email *****@mail.com
 * @date 2025-08-18 14:29:47
 */
@Mapper
public interface JscSjytGzjyMapper extends BaseMapper<JscSjytGzjyEntity> {

    @Select("select id,data_index,refine_name,ascription,num1,num2,num3,num4,num5,num6,num7,num8,num9,num10,num11,time_type,time_value,year,source,admin_dis,update_time " +
            "from jsc_sjyt_gzjy where REPLACE(REPLACE(ascription, '（', ''), '）', '') = #{ascription} ORDER BY year desc,time_value desc,id desc ;")
    List<JscSjytGzjyEntity> selectByAscription(String ascription);
}
